using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;

namespace DataModels.Models
{
    public partial class ExcelTemplateSheet
    {
        [Key]
        [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
        public int SheetID { get; set; }        

        [StringLength(1000)]
        public string TemplateSheetName { get; set; }

        [StringLength(1000)]
        public string OutputSheetName { get; set; }

        [StringLength(1000)]
        public string OutputsheetNameTemplate { get; set; }

        public bool HasRepetitiveRows { get; set; }
        public bool HasRepetitiveColumns { get; set; }
        public Nullable<int> FirstRepetitiveColumnCellIndex { get; set; }
        public Nullable<int> FirstRepetitiveRowCellIndex { get; set; }
        public Nullable<int> LastRepetitiveColumnCellIndex { get; set; }
        public Nullable<int> LastRepetitiveRowCellIndex { get; set; }

        public int TemplateID { get; set; }

        [ForeignKey("TemplateID")]
        public virtual ExcelTemplateReport ExcelTemplateReport { get; set; }

        public virtual List<ExcelTemplateCell> ExcelTemplateCells { get; set; }
    }
}
